Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	20000
Missing cells	8261
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	128.0 B

Variable types

Numeric	10
Categorical	6

Warnings

`name` has a high cardinality: 19768 distinct values	High cardinality
`host_name` has a high cardinality: 6517 distinct values	High cardinality
`neighbourhood` has a high cardinality: 217 distinct values	High cardinality
`last_review` has a high cardinality: 1507 distinct values	High cardinality
`last_review` has 4123 (20.6%) missing values	Missing
`reviews_per_month` has 4123 (20.6%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 25.17996962)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 4123 (20.6%) zeros	Zeros
`availability_365` has 7176 (35.9%) zeros	Zeros

Reproduction

Analysis started	2023-09-02 15:07:24.245853
Analysis finished	2023-09-02 15:07:37.652885
Duration	13.41 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

id
Real number (ℝ_≥0)

UNIQUE

Distinct	20000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18923800.78
Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2539
5-th percentile	1193873.85
Q1	9393540.5
median	19521168.5
Q3	29129358.75
95-th percentile	35275607.45
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19735818.25

Descriptive statistics

Standard deviation	11012232.42
Coefficient of variation (CV)	0.5819249812
Kurtosis	-1.233322955
Mean	18923800.78
Median Absolute Deviation (MAD)	9896304
Skewness	-0.07538052651
Sum	3.784760157 × 10¹¹
Variance	1.212692628 × 10¹⁴
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32493112	1	< 0.1%
2728293	1	< 0.1%
30741302	1	< 0.1%
5354796	1	< 0.1%
36308266	1	< 0.1%
31194309	1	< 0.1%
15509545	1	< 0.1%
13073701	1	< 0.1%
20775370	1	< 0.1%
169152	1	< 0.1%
Other values (19990)	19990	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	19768
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	156.4 KiB

Brooklyn Apartment	7
Hillside Hotel	7
New york Multi-unit building	6
Private Room	6
Home away from home	6
Other values (19763)	19961

Length

Max length	179
Median length	36
Mean length	36.90246586
Min length	1

Characters and Unicode

Total characters	737791
Distinct characters	511
Distinct categories	20 ?
Distinct scripts	11 ?
Distinct blocks	17 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19599 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Value	Count	Frequency (%)
Brooklyn Apartment	7	< 0.1%
Hillside Hotel	7	< 0.1%
New york Multi-unit building	6	< 0.1%
Private Room	6	< 0.1%
Home away from home	6	< 0.1%
Cozy Room	5	< 0.1%
Private room in Manhattan	5	< 0.1%
Cozy Private Room	4	< 0.1%
Private room in Williamsburg	4	< 0.1%
Private room in Brooklyn	3	< 0.1%
Other values (19758)	19940	99.7%
(Missing)	7	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
in	6813	5.6%
room	4038	3.3%
	3388	2.8%
bedroom	3145	2.6%
private	2935	2.4%
apartment	2748	2.2%
cozy	2034	1.7%
apt	1843	1.5%
brooklyn	1666	1.4%
the	1620	1.3%
Other values (7025)	91941	75.3%

Most occurring characters

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	493004	66.8%
Uppercase Letter	110782	15.0%
Space Separator	102880	13.9%
Other Punctuation	13747	1.9%
Decimal Number	10518	1.4%
Dash Punctuation	2806	0.4%
Math Symbol	1072	0.1%
Other Letter	987	0.1%
Close Punctuation	647	0.1%
Open Punctuation	593	0.1%
Other values (10)	755	0.1%

Most frequent character per category

Value	Count	Frequency (%)
房	37	3.7%
间	22	2.2%
中	21	2.1%
拉	20	2.0%
法	19	1.9%
盛	19	1.9%
家	16	1.6%
温	15	1.5%
的	15	1.5%
馨	13	1.3%
Other values (301)	790	80.0%

Value	Count	Frequency (%)
e	50869	10.3%
o	50103	10.2%
t	42994	8.7%
a	42392	8.6%
r	40165	8.1%
i	38708	7.9%
n	38494	7.8%
l	21159	4.3%
m	20160	4.1%
s	19736	4.0%
Other values (48)	128224	26.0%

Value	Count	Frequency (%)
★	129	32.9%
❤	70	17.9%
☆	31	7.9%
⭐	19	4.8%
✨	17	4.3%
♥	14	3.6%
❥	13	3.3%
✰	8	2.0%
✿	7	1.8%
☀	6	1.5%
Other values (32)	78	19.9%

Value	Count	Frequency (%)
B	12285	11.1%
S	10802	9.8%
C	8612	7.8%
A	7957	7.2%
R	7399	6.7%
P	6047	5.5%
E	5906	5.3%
L	5757	5.2%
M	4841	4.4%
T	4763	4.3%
Other values (23)	36413	32.9%

Value	Count	Frequency (%)
,	3685	26.8%
!	3209	23.3%
/	2153	15.7%
.	1778	12.9%
&	1292	9.4%
'	441	3.2%
*	402	2.9%
:	239	1.7%
#	232	1.7%
"	113	0.8%
Other values (9)	203	1.5%

Value	Count	Frequency (%)
1	3559	33.8%
2	2852	27.1%
3	1087	10.3%
5	916	8.7%
0	841	8.0%
4	562	5.3%
6	253	2.4%
8	167	1.6%
7	164	1.6%
9	117	1.1%

Value	Count	Frequency (%)
+	529	49.3%
\|	397	37.0%
~	108	10.1%
=	12	1.1%
>	10	0.9%
<	7	0.7%
￫	6	0.6%
√	2	0.2%
×	1	0.1%

Value	Count	Frequency (%)
(	568	95.8%
[	16	2.7%
{	4	0.7%
【	3	0.5%
《	2	0.3%

Value	Count	Frequency (%)
)	621	96.0%
]	17	2.6%
}	4	0.6%
】	3	0.5%
》	2	0.3%

Value	Count	Frequency (%)
-	2771	98.8%
—	19	0.7%
–	16	0.6%

Value	Count	Frequency (%)
	102878	> 99.9%
	2	< 0.1%

Value	Count	Frequency (%)
’	95	87.2%
”	14	12.8%

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Value	Count	Frequency (%)
“	15	78.9%
‘	4	21.1%

Value	Count	Frequency (%)
ﾞ	7	70.0%
ｰ	3	30.0%

Value	Count	Frequency (%)
^	6	85.7%
`	1	14.3%

Value	Count	Frequency (%)
	74	100.0%

Value	Count	Frequency (%)
$	36	100.0%

Value	Count	Frequency (%)
_	20	100.0%

Value	Count	Frequency (%)
²	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	603703	81.8%
Common	132937	18.0%
Han	889	0.1%
Inherited	81	< 0.1%
Cyrillic	71	< 0.1%
Katakana	45	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Hiragana	12	< 0.1%
Hangul	8	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
房	37	4.2%
间	22	2.5%
中	21	2.4%
拉	20	2.2%
法	19	2.1%
盛	19	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (246)	692	77.8%

Value	Count	Frequency (%)
	102878	77.4%
,	3685	2.8%
1	3559	2.7%
!	3209	2.4%
2	2852	2.1%
-	2771	2.1%
/	2153	1.6%
.	1778	1.3%
&	1292	1.0%
3	1087	0.8%
Other values (97)	7673	5.8%

Value	Count	Frequency (%)
e	50869	8.4%
o	50103	8.3%
t	42994	7.1%
a	42392	7.0%
r	40165	6.7%
i	38708	6.4%
n	38494	6.4%
l	21159	3.5%
m	20160	3.3%
s	19736	3.3%
Other values (61)	238923	39.6%

Value	Count	Frequency (%)
ﾝ	7	15.6%
ﾄ	5	11.1%
ｯ	3	6.7%
ﾀ	3	6.7%
ｳ	3	6.7%
ｸ	3	6.7%
ﾐ	2	4.4%
ｽ	2	4.4%
ｴ	1	2.2%
ｻ	1	2.2%
Other values (15)	15	33.3%

Value	Count	Frequency (%)
а	10	14.1%
н	7	9.9%
т	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
м	4	5.6%
е	4	5.6%
я	3	4.2%
р	3	4.2%
Other values (9)	16	22.5%

Value	Count	Frequency (%)
י	5	16.1%
ו	5	16.1%
ב	4	12.9%
ר	4	12.9%
ע	2	6.5%
ת	2	6.5%
ה	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Value	Count	Frequency (%)
따	1	12.5%
뜻	1	12.5%
한	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
물	1	12.5%
웃	1	12.5%

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
に	1	8.3%
い	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Value	Count	Frequency (%)
ॐ	2	100.0%

Value	Count	Frequency (%)
ღ	12	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	735931	99.7%
CJK	889	0.1%
Misc Symbols	220	< 0.1%
Punctuation	200	< 0.1%
None	182	< 0.1%
Dingbats	143	< 0.1%
VS	81	< 0.1%
Cyrillic	71	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Other values (7)	31	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	102878	14.0%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.8%
r	40165	5.5%
i	38708	5.3%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (86)	288009	39.1%

Value	Count	Frequency (%)
❤	70	49.0%
✨	17	11.9%
❥	13	9.1%
✰	8	5.6%
✿	7	4.9%
✪	5	3.5%
✴	4	2.8%
✦	4	2.8%
✮	3	2.1%
✤	3	2.1%
Other values (5)	9	6.3%

Value	Count	Frequency (%)
房	37	4.2%
间	22	2.5%
中	21	2.4%
拉	20	2.2%
法	19	2.1%
盛	19	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (246)	692	77.8%

Value	Count	Frequency (%)
’	95	47.5%
•	37	18.5%
—	19	9.5%
–	16	8.0%
“	15	7.5%
”	14	7.0%
‘	4	2.0%

Value	Count	Frequency (%)
★	129	58.6%
☆	31	14.1%
♥	14	6.4%
☀	6	2.7%
⚡	6	2.7%
♦	6	2.7%
♀	5	2.3%
⚓	3	1.4%
☺	3	1.4%
♕	3	1.4%
Other values (8)	14	6.4%

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Value	Count	Frequency (%)
⭐	19	10.4%
à	15	8.2%
ó	9	4.9%
｡	7	3.8%
·	7	3.8%
²	7	3.8%
é	7	3.8%
ﾞ	7	3.8%
ﾝ	7	3.8%
￫	6	3.3%
Other values (51)	91	50.0%

Value	Count	Frequency (%)
ॐ	2	100.0%

Value	Count	Frequency (%)
™	1	100.0%

Value	Count	Frequency (%)
⍟	2	50.0%
⏩	1	25.0%
⏪	1	25.0%

Value	Count	Frequency (%)
√	2	100.0%

Value	Count	Frequency (%)
ღ	12	100.0%

Value	Count	Frequency (%)
а	10	14.1%
н	7	9.9%
т	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
м	4	5.6%
е	4	5.6%
я	3	4.2%
р	3	4.2%
Other values (9)	16	22.5%

Value	Count	Frequency (%)
▲	2	100.0%

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
に	1	8.3%
い	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Value	Count	Frequency (%)
י	5	16.1%
ו	5	16.1%
ב	4	12.9%
ר	4	12.9%
ע	2	6.5%
ת	2	6.5%
ה	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Value	Count	Frequency (%)
따	1	12.5%
뜻	1	12.5%
한	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
물	1	12.5%
웃	1	12.5%

host_id
Real number (ℝ_≥0)

Distinct	17027
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	67460344.07
Minimum	2571
Maximum	274273284
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2571
5-th percentile	779450
Q1	7853718.25
median	31114309.5
Q3	106842560
95-th percentile	242095840.9
Maximum	274273284
Range	274270713
Interquartile range (IQR)	98988841.75

Descriptive statistics

Standard deviation	78579364.8
Coefficient of variation (CV)	1.164823066
Kurtosis	0.2087986308
Mean	67460344.07
Median Absolute Deviation (MAD)	27863859.5
Skewness	1.219649017
Sum	1.349206881 × 10¹²
Variance	6.174716572 × 10¹⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	131	0.7%
107434423	89	0.4%
30283594	53	0.3%
12243051	37	0.2%
16098958	36	0.2%
137358866	36	0.2%
61391963	34	0.2%
22541573	32	0.2%
200380610	27	0.1%
2856748	24	0.1%
Other values (17017)	19501	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
274079964	1	< 0.1%
273870123	1	< 0.1%

host_name
Categorical

HIGH CARDINALITY

Distinct	6517
Distinct (%)	32.6%
Missing	8
Missing (%)	< 0.1%
Memory size	156.4 KiB

David	170
Michael	167
John	133
Sonder (NYC)	131
Alex	105
Other values (6512)	19286

Length

Max length	35
Median length	6
Mean length	6.112444978
Min length	1

Characters and Unicode

Total characters	122200
Distinct characters	140
Distinct categories	11 ?
Distinct scripts	6 ?
Distinct blocks	7 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4203 ?
Unique (%)	21.0%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Value	Count	Frequency (%)
David	170	0.9%
Michael	167	0.8%
John	133	0.7%
Sonder (NYC)	131	0.7%
Alex	105	0.5%
Daniel	95	0.5%
Blueground	89	0.4%
Maria	87	0.4%
Sarah	87	0.4%
Chris	83	0.4%
Other values (6507)	18845	94.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
	428	1.9%
and	250	1.1%
david	185	0.8%
michael	183	0.8%
sonder	168	0.8%
john	148	0.7%
nyc	137	0.6%
alex	129	0.6%
laura	121	0.5%
maria	109	0.5%
Other values (6048)	20426	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	96373	78.9%
Uppercase Letter	22409	18.3%
Space Separator	2334	1.9%
Other Punctuation	616	0.5%
Open Punctuation	149	0.1%
Close Punctuation	149	0.1%
Dash Punctuation	77	0.1%
Other Letter	41	< 0.1%
Decimal Number	36	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	15469	16.1%
e	11787	12.2%
i	9892	10.3%
n	9892	10.3%
r	7360	7.6%
l	6239	6.5%
o	5194	5.4%
t	3817	4.0%
s	3737	3.9%
h	3686	3.8%
Other values (46)	19300	20.0%

Value	Count	Frequency (%)
A	2627	11.7%
J	2215	9.9%
M	2152	9.6%
S	1914	8.5%
C	1517	6.8%
L	1177	5.3%
D	1132	5.1%
R	1085	4.8%
K	1070	4.8%
E	970	4.3%
Other values (22)	6550	29.2%

Value	Count	Frequency (%)
美	3	7.3%
德	3	7.3%
青	3	7.3%
明	3	7.3%
辣	2	4.9%
柏	2	4.9%
润	2	4.9%
铀	2	4.9%
泽	1	2.4%
宇	1	2.4%
Other values (19)	19	46.3%

Value	Count	Frequency (%)
&	445	72.2%
.	129	20.9%
/	14	2.3%
,	13	2.1%
'	7	1.1%
!	4	0.6%
@	3	0.5%
:	1	0.2%

Value	Count	Frequency (%)
5	11	30.6%
0	6	16.7%
7	6	16.7%
1	4	11.1%
2	3	8.3%
4	3	8.3%
6	2	5.6%
3	1	2.8%

Value	Count	Frequency (%)
	2330	99.8%
	4	0.2%

Value	Count	Frequency (%)
(	149	100.0%

Value	Count	Frequency (%)
)	149	100.0%

Value	Count	Frequency (%)
-	77	100.0%

Value	Count	Frequency (%)
+	15	100.0%

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118759	97.2%
Common	3377	2.8%
Han	36	< 0.1%
Cyrillic	23	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
a	15469	13.0%
e	11787	9.9%
i	9892	8.3%
n	9892	8.3%
r	7360	6.2%
l	6239	5.3%
o	5194	4.4%
t	3817	3.2%
s	3737	3.1%
h	3686	3.1%
Other values (63)	41686	35.1%

Value	Count	Frequency (%)
美	3	8.3%
德	3	8.3%
青	3	8.3%
明	3	8.3%
辣	2	5.6%
柏	2	5.6%
润	2	5.6%
铀	2	5.6%
泽	1	2.8%
宇	1	2.8%
Other values (14)	14	38.9%

Value	Count	Frequency (%)
	2330	69.0%
&	445	13.2%
(	149	4.4%
)	149	4.4%
.	129	3.8%
-	77	2.3%
+	15	0.4%
/	14	0.4%
,	13	0.4%
5	11	0.3%
Other values (13)	45	1.3%

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
н	2	8.7%
й	2	8.7%
и	2	8.7%
л	2	8.7%
д	1	4.3%
р	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	122025	99.9%
None	107	0.1%
CJK	36	< 0.1%
Cyrillic	23	< 0.1%
Punctuation	4	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.7%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (63)	44952	36.8%

Value	Count	Frequency (%)
é	43	40.2%
í	10	9.3%
á	10	9.3%
ë	8	7.5%
ô	6	5.6%
è	6	5.6%
ú	5	4.7%
ó	2	1.9%
ç	2	1.9%
ı	2	1.9%
Other values (12)	13	12.1%

Value	Count	Frequency (%)
美	3	8.3%
德	3	8.3%
青	3	8.3%
明	3	8.3%
辣	2	5.6%
柏	2	5.6%
润	2	5.6%
铀	2	5.6%
泽	1	2.8%
宇	1	2.8%
Other values (14)	14	38.9%

Value	Count	Frequency (%)
	4	100.0%

Value	Count	Frequency (%)
А	3	13.0%
е	3	13.0%
н	2	8.7%
й	2	8.7%
и	2	8.7%
л	2	8.7%
д	1	4.3%
р	1	4.3%
т	1	4.3%
а	1	4.3%
Other values (5)	5	21.7%

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Value	Count	Frequency (%)
소	1	50.0%
정	1	50.0%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Manhattan	8774
Brooklyn	8265
Queens	2355
Bronx	441
Staten Island	165

Length

Max length	13
Median length	8
Mean length	8.1783
Min length	5

Characters and Unicode

Total characters	163566
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Value	Count	Frequency (%)
Manhattan	8774	43.9%
Brooklyn	8265	41.3%
Queens	2355	11.8%
Bronx	441	2.2%
Staten Island	165	0.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
manhattan	8774	43.5%
brooklyn	8265	41.0%
queens	2355	11.7%
bronx	441	2.2%
staten	165	0.8%
island	165	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
k	8265	5.1%
Other values (10)	21471	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	143236	87.6%
Uppercase Letter	20165	12.3%
Space Separator	165	0.1%

Most frequent character per category

Value	Count	Frequency (%)
n	28939	20.2%
a	26652	18.6%
t	17878	12.5%
o	16971	11.8%
h	8774	6.1%
r	8706	6.1%
l	8430	5.9%
k	8265	5.8%
y	8265	5.8%
e	4875	3.4%
Other values (4)	5481	3.8%

Value	Count	Frequency (%)
M	8774	43.5%
B	8706	43.2%
Q	2355	11.7%
S	165	0.8%
I	165	0.8%

Value	Count	Frequency (%)
	165	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	163401	99.9%
Common	165	0.1%

Most frequent character per script

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
k	8265	5.1%
Other values (9)	21306	13.0%

Value	Count	Frequency (%)
	165	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	163566	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
k	8265	5.1%
Other values (10)	21471	13.1%

neighbourhood
Categorical

HIGH CARDINALITY

Distinct	217
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Williamsburg	1580
Bedford-Stuyvesant	1503
Harlem	1116
Bushwick	987
Upper West Side	798
Other values (212)	14016

Length

Max length	26
Median length	12
Mean length	11.8819
Min length	4

Characters and Unicode

Total characters	237638
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Value	Count	Frequency (%)
Williamsburg	1580	7.9%
Bedford-Stuyvesant	1503	7.5%
Harlem	1116	5.6%
Bushwick	987	4.9%
Upper West Side	798	4.0%
Hell's Kitchen	771	3.9%
East Village	756	3.8%
Upper East Side	706	3.5%
Crown Heights	648	3.2%
Midtown	643	3.2%
Other values (207)	10492	52.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
east	2690	8.3%
side	1872	5.8%
williamsburg	1580	4.9%
harlem	1579	4.9%
upper	1504	4.7%
bedford-stuyvesant	1503	4.6%
heights	1462	4.5%
village	1301	4.0%
west	1142	3.5%
bushwick	987	3.1%
Other values (229)	16713	51.7%

Most occurring characters

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	188434	79.3%
Uppercase Letter	34309	14.4%
Space Separator	12333	5.2%
Dash Punctuation	1736	0.7%
Other Punctuation	826	0.3%

Most frequent character per category

Value	Count	Frequency (%)
e	21824	11.6%
i	17188	9.1%
s	16285	8.6%
t	15839	8.4%
a	15504	8.2%
l	14091	7.5%
r	13837	7.3%
n	10687	5.7%
o	9832	5.2%
d	7969	4.2%
Other values (15)	45378	24.1%

Value	Count	Frequency (%)
H	4904	14.3%
S	4653	13.6%
B	3373	9.8%
W	3327	9.7%
E	2888	8.4%
C	2238	6.5%
U	1535	4.5%
G	1532	4.5%
F	1380	4.0%
V	1324	3.9%
Other values (14)	7155	20.9%

Value	Count	Frequency (%)
'	776	93.9%
.	49	5.9%
,	1	0.1%

Value	Count	Frequency (%)
	12333	100.0%

Value	Count	Frequency (%)
-	1736	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	222743	93.7%
Common	14895	6.3%

Most frequent character per script

Value	Count	Frequency (%)
e	21824	9.8%
i	17188	7.7%
s	16285	7.3%
t	15839	7.1%
a	15504	7.0%
l	14091	6.3%
r	13837	6.2%
n	10687	4.8%
o	9832	4.4%
d	7969	3.6%
Other values (39)	79687	35.8%

Value	Count	Frequency (%)
	12333	82.8%
-	1736	11.7%
'	776	5.2%
.	49	0.3%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237638	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

latitude
Real number (ℝ_≥0)

Distinct	12439
Distinct (%)	62.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.72845515
Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.6451295
Q1	40.68942
median	40.72273
Q3	40.76299
95-th percentile	40.8256525
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07357

Descriptive statistics

Standard deviation	0.05475507699
Coefficient of variation (CV)	0.001344393663
Kurtosis	0.1085655141
Mean	40.72845515
Median Absolute Deviation (MAD)	0.03658
Skewness	0.2301693808
Sum	814569.103
Variance	0.002998118457
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.68634	8	< 0.1%
40.72232	8	< 0.1%
40.71813	8	< 0.1%
40.69414	8	< 0.1%
40.72607	7	< 0.1%
40.68683	7	< 0.1%
40.70587	7	< 0.1%
40.71801	7	< 0.1%
40.68084	7	< 0.1%
40.71992	6	< 0.1%
Other values (12429)	19927	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53076	1	< 0.1%
40.53871	1	< 0.1%
40.53884	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%

longitude
Real number (ℝ)

Distinct	10181
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-73.95212502
Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.0041805
Q1	-73.98303
median	-73.95564
Q3	-73.93638
95-th percentile	-73.864896
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04665

Descriptive statistics

Standard deviation	0.04655878323
Coefficient of variation (CV)	-0.000629580059
Kurtosis	4.938242884
Mean	-73.95212502
Median Absolute Deviation (MAD)	0.024895
Skewness	1.255100378
Sum	-1479042.5
Variance	0.002167720296
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.98589	10	0.1%
-73.94829	9	< 0.1%
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.95121	9	< 0.1%
-73.98043	9	< 0.1%
-73.95725	9	< 0.1%
-73.95332	8	< 0.1%
-73.95675	8	< 0.1%
-73.95509	8	< 0.1%
Other values (10171)	19912	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.20295	1	< 0.1%
-74.19826	1	< 0.1%
-74.19626	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.4 KiB

Entire home/apt	10384
Private room	9172
Shared room	444

Length

Max length	15
Median length	15
Mean length	13.5354
Min length	11

Characters and Unicode

Total characters	270708
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Value	Count	Frequency (%)
Entire home/apt	10384	51.9%
Private room	9172	45.9%
Shared room	444	2.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
home/apt	10384	26.0%
entire	10384	26.0%
room	9616	24.0%
private	9172	22.9%
shared	444	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
r	29616	10.9%
o	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
E	10384	3.8%
Other values (7)	50384	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	220324	81.4%
Uppercase Letter	20000	7.4%
Space Separator	20000	7.4%
Other Punctuation	10384	3.8%

Most frequent character per category

Value	Count	Frequency (%)
e	30384	13.8%
t	29940	13.6%
r	29616	13.4%
o	29616	13.4%
a	20000	9.1%
m	20000	9.1%
i	19556	8.9%
h	10828	4.9%
n	10384	4.7%
p	10384	4.7%
Other values (2)	9616	4.4%

Value	Count	Frequency (%)
E	10384	51.9%
P	9172	45.9%
S	444	2.2%

Value	Count	Frequency (%)
	20000	100.0%

Value	Count	Frequency (%)
/	10384	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	240324	88.8%
Common	30384	11.2%

Most frequent character per script

Value	Count	Frequency (%)
e	30384	12.6%
t	29940	12.5%
r	29616	12.3%
o	29616	12.3%
a	20000	8.3%
m	20000	8.3%
i	19556	8.1%
h	10828	4.5%
E	10384	4.3%
n	10384	4.3%
Other values (5)	29616	12.3%

Value	Count	Frequency (%)
	20000	65.8%
/	10384	34.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	270708	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
r	29616	10.9%
o	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
E	10384	3.8%
Other values (7)	50384	18.6%

price
Real number (ℝ_≥0)

Distinct	544
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	153.26905
Minimum	0
Maximum	10000
Zeros	5
Zeros (%)	< 0.1%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	69
median	105
Q3	175
95-th percentile	350
Maximum	10000
Range	10000
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	243.3256089
Coefficient of variation (CV)	1.587571717
Kurtosis	538.297578
Mean	153.26905
Median Absolute Deviation (MAD)	45
Skewness	18.3046896
Sum	3065381
Variance	59207.35193
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.3%
150	821	4.1%
50	636	3.2%
200	590	2.9%
75	570	2.9%
60	555	2.8%
80	531	2.7%
70	482	2.4%
120	471	2.4%
65	471	2.4%
Other values (534)	14017	70.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	< 0.1%
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
8500	1	< 0.1%
7703	1	< 0.1%
7500	1	< 0.1%

minimum_nights
Real number (ℝ_≥0)

SKEWED

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.9921
Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.64544903
Coefficient of variation (CV)	3.095700724
Kurtosis	1072.167601
Mean	6.9921
Median Absolute Deviation (MAD)	1
Skewness	25.17996962
Sum	139842
Variance	468.5254639
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
30	1540	7.7%
4	1328	6.6%
5	1208	6.0%
7	855	4.3%
6	307	1.5%
14	217	1.1%
10	183	0.9%
Other values (65)	1009	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
4	1328	6.6%
5	1208	6.0%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%

number_of_reviews
Real number (ℝ_≥0)

ZEROS

Distinct	323
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.2741
Minimum	0
Maximum	607
Zeros	4123
Zeros (%)	20.6%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	23
95-th percentile	114
Maximum	607
Range	607
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	44.92779312
Coefficient of variation (CV)	1.930377248
Kurtosis	20.22980666
Mean	23.2741
Median Absolute Deviation (MAD)	5
Skewness	3.761375507
Sum	465482
Variance	2018.506595
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%
Other values (313)	7919	39.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%

last_review
Categorical

HIGH CARDINALITY
MISSING

Distinct	1507
Distinct (%)	9.5%
Missing	4123
Missing (%)	20.6%
Memory size	156.4 KiB

2019-06-23	575
2019-07-01	557
2019-06-30	553
2019-06-24	350
2019-07-07	292
Other values (1502)	13550

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	158770
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	358 ?
Unique (%)	2.3%

Sample

1st row	2019-05-26
2nd row	2018-09-19
3rd row	2019-05-24
4th row	2019-06-23
5th row	2018-08-28

Value	Count	Frequency (%)
2019-06-23	575	2.9%
2019-07-01	557	2.8%
2019-06-30	553	2.8%
2019-06-24	350	1.8%
2019-07-07	292	1.5%
2019-07-02	280	1.4%
2019-06-22	270	1.4%
2019-07-05	252	1.3%
2019-06-16	245	1.2%
2019-07-06	240	1.2%
Other values (1497)	12263	61.3%
(Missing)	4123	20.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-06-23	575	3.6%
2019-07-01	557	3.5%
2019-06-30	553	3.5%
2019-06-24	350	2.2%
2019-07-07	292	1.8%
2019-07-02	280	1.8%
2019-06-22	270	1.7%
2019-07-05	252	1.6%
2019-06-16	245	1.5%
2019-07-06	240	1.5%
Other values (1497)	12263	77.2%

Most occurring characters

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	127016	80.0%
Dash Punctuation	31754	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	37740	29.7%
1	25367	20.0%
2	23933	18.8%
9	12270	9.7%
6	8098	6.4%
7	5309	4.2%
8	4494	3.5%
5	3914	3.1%
3	3634	2.9%
4	2257	1.8%

Value	Count	Frequency (%)
-	31754	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	158770	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	158770	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

reviews_per_month
Real number (ℝ_≥0)

MISSING

Distinct	790
Distinct (%)	5.0%
Missing	4123
Missing (%)	20.6%
Infinite	0
Infinite (%)	0.0%

Mean	1.377445991
Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.67
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.683005621
Coefficient of variation (CV)	1.22183057
Kurtosis	11.95169963
Mean	1.377445991
Median Absolute Deviation (MAD)	0.62
Skewness	2.435799259
Sum	21869.71
Variance	2.83250792
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	378	1.9%
0.02	378	1.9%
0.05	352	1.8%
0.03	334	1.7%
0.04	274	1.4%
0.08	263	1.3%
0.16	255	1.3%
0.09	246	1.2%
0.06	234	1.2%
0.11	222	1.1%
Other values (780)	12941	64.7%
(Missing)	4123	20.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	18	0.1%
0.02	378	1.9%
0.03	334	1.7%
0.04	274	1.4%
0.05	352	1.8%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%

calculated_host_listings_count
Real number (ℝ_≥0)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.95545
Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	14
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	32.43383053
Coefficient of variation (CV)	4.663081545
Kurtosis	70.36535249
Mean	6.95545
Median Absolute Deviation (MAD)	0
Skewness	8.096123898
Sum	139109
Variance	1051.953363
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
8	168	0.8%
7	166	0.8%
327	131	0.7%
9	103	0.5%
Other values (37)	1123	5.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%

Value	Count	Frequency (%)
327	131	0.7%
232	89	0.4%
121	53	0.3%
103	36	0.2%
96	73	0.4%

availability_365
Real number (ℝ_≥0)

ZEROS

Distinct	366
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	112.9012
Minimum	0
Maximum	365
Zeros	7176
Zeros (%)	35.9%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44
Q3	229
95-th percentile	359
Maximum	365
Range	365
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	131.7622264
Coefficient of variation (CV)	1.167057803
Kurtosis	-1.007092224
Mean	112.9012
Median Absolute Deviation (MAD)	44
Skewness	0.75940929
Sum	2258024
Variance	17361.2843
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7176	35.9%
365	510	2.5%
364	225	1.1%
1	181	0.9%
5	136	0.7%
89	124	0.6%
179	121	0.6%
2	119	0.6%
3	118	0.6%
4	110	0.5%
Other values (356)	11180	55.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7176	35.9%
1	181	0.9%
2	119	0.6%
3	118	0.6%
4	110	0.5%

Value	Count	Frequency (%)
365	510	2.5%
364	225	1.1%
363	98	0.5%
362	69	0.3%
361	48	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaN	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaN	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows